revDatabaseColumnTypes

Type

function

Summary

Returns the data types of the columns in a record set.

Syntax

revDatabaseColumnTypes(<recordSetID>)

Description

Use the revDatabaseColumnTypes function to find out the data type of a database field.

The possible data types are:

        * BIT
        * CHAR
        * STRING
        * WSTRING
        * BLOB (short for binary large object)
        * TIMESTAMP
        * DATE
        * TIME
        * DATETIME
        * FLOAT
        * DOUBLE
        * INTEGER
        * SMALLINT
        * WORD
        * BOOLEAN
        * LONG

You can use the revDatabaseColumnTypes function to find out what kind of data you need to be prepared for. For example, if BLOB is one of the data types, that column is binary data, so you should not attempt to display it in a field.

Important

The revDatabaseColumnTypes function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.

Parameters

Name	Type	Description
recordSetID		The number returned by the revQueryDatabase function when the record set was created.

Examples

revDatabaseColumnTypes(the savedCursor of field 1)

if "BLOB" is among the items of revDatabaseColumnTypes(myCursor) then
  put true into preferQueryBlob
end if

Value

Name	Type	Description
return		The revDatabaseColumnTypes function returns a list of data types, one for each column in the record set, separated by commas.

Related

control structure: function

function: revDatabaseColumnNames, revDatabaseColumnLengths, revDatabaseType

glossary: LiveCode custom library, return, binary file, record set, Standalone Application Settings, standalone application, column, database field, BLOB

keyword: field

library: Database library

Compatibility and Support

Introduced

LiveCode 1.1.1

OS

mac

windows

linux

ios

android

Platforms

desktop

server

mobile